﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_BLZY')
            and   type = 'U')
   drop table GXBZ_EMR_BLZY
go

/*==============================================================*/
/* Table: GXBZ_EMR_BLZY                                         */
/*==============================================================*/
create table GXBZ_EMR_BLZY (
   BLLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   JKKH                 varchar(64)          null,
   YBKHBS               varchar(20)          null,
   JDRQ                 datetime             null,
   KFSSGH               varchar(64)          null,
   KFYSXM               varchar(30)          null,
   JDJGDM               varchar(22)          null,
   JDJGMC               varchar(70)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   LXRDZMPH             varchar(70)          null,
   LXRDZCMC             varchar(70)          null,
   LXRDZXMC             varchar(70)          null,
   LXRDZQXMC            varchar(70)          null,
   LXRDZSMC             varchar(70)          null,
   LXRDZSSMC            varchar(70)          null,
   LXRDZYB              varchar(6)           null,
   LXRXXDZ              varchar(200)         null,
   LXRDZDHHM            varchar(20)          null,
   LXRXM                varchar(30)          null,
   ABOXXDM              varchar(1)           null,
   RHXXDM               varchar(1)           null,
   JBSHWS               varchar(1024)        null,
   CRBS                 varchar(1024)        null,
   SSS                  varchar(1024)        null,
   HYS                  varchar(1024)        null,
   SXS                  varchar(1024)        null,
   GMS                  varchar(1024)        null,
   YFJZS                varchar(1024)        null,
   GRS                  varchar(1024)        null,
   YJS                  varchar(1024)        null,
   JZS                  varchar(1024)        null,
   YLJGKSMC             varchar(32)          null,
   HZLX                 varchar(1)           null,
   MJZH                 varchar(32)          null,
   ZYH                  varchar(32)          null,
   RYRQSJ               datetime             null,
   CYRQSJ               datetime             null,
   FBRQSJ               datetime             null,
   JZRQSJ               datetime             null,
   JZYY                 varchar(1024)        null,
   XYZDDM               varchar(10)          null,
   BQZGDM               varchar(1)           null,
   QTXYDM               varchar(10)          null,
   ZYBMDM               varchar(10)          null,
   ZYZHDM               varchar(10)          null,
   SSJCZBM              varchar(50)          null,
   GJYWMC               varchar(50)          null,
   ZYSYLBDM             varchar(1)           null,
   QTYXCZ               varchar(2000)        null,
   GBSYDM               varchar(50)          null,
   ZRYSXM               varchar(30)          null,
   YLBXLBDM             varchar(50)          null,
   YLFKFSDM             varchar(2)           null,
   MZFYJE               decimal(18,3)        null,
   ZYFYJE               decimal(18,3)        null,
   GRCDFYJE             decimal(18,3)        null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_BLZY primary key (BLLSH, XGBZ)
)
go
